NTISthis.com

Evidence Guide: ICTPRG403 - Develop data-driven applications

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTPRG403 - Develop data-driven applications

What evidence can you provide to prove your understanding of each of the following citeria?

Select data-access layer (DAL)

  1. Review function of DAL in multi-layer application model
  2. Determine data-access application programming interface (API) for connecting to various data sources
Review function of DAL in multi-layer application model

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine data-access application programming interface (API) for connecting to various data sources

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Establish connection with data source

  1. Create and manage connection strings
  2. Connect to data source by using different data providers
  3. Create code to handle connection exceptions
Create and manage connection strings

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Connect to data source by using different data providers

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create code to handle connection exceptions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Execute commands and return results from data source

  1. Query data from data source
  2. Retrieve data from data source as result sets
  3. Manage result sets
  4. Manage exceptions when retrieving data
Query data from data source

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Retrieve data from data source as result sets

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manage result sets

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manage exceptions when retrieving data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Modify data in data source

  1. Insert, update or delete data
  2. Manage data integrity
  3. Manage exceptions when modifying data
Insert, update or delete data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manage data integrity

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manage exceptions when modifying data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Manage disconnected data

  1. Research disconnected data management strategy
  2. Ensure that application can deal with disconnected data
Research disconnected data management strategy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure that application can deal with disconnected data

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document data-access layer

  1. Document code
  2. Document database connectivity
Document code

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document database connectivity

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Select data-access layer (DAL)

1.1 Review function of DAL in multi-layer application model

1.2 Determine data-access application programming interface (API) for connecting to various data sources

2. Establish connection with data source

2.1 Create and manage connection strings

2.2 Connect to data source by using different data providers

2.3 Create code to handle connection exceptions

3. Execute commands and return results from data source

3.1 Query data from data source

3.2 Retrieve data from data source as result sets

3.3 Manage result sets

3.4 Manage exceptions when retrieving data

4. Modify data in data source

4.1 Insert, update or delete data

4.2 Manage data integrity

4.3 Manage exceptions when modifying data

5. Manage disconnected data

5.1 Research disconnected data management strategy

5.2 Ensure that application can deal with disconnected data

6. Document data-access layer

6.1 Document code

6.2 Document database connectivity

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Select data-access layer (DAL)

1.1 Review function of DAL in multi-layer application model

1.2 Determine data-access application programming interface (API) for connecting to various data sources

2. Establish connection with data source

2.1 Create and manage connection strings

2.2 Connect to data source by using different data providers

2.3 Create code to handle connection exceptions

3. Execute commands and return results from data source

3.1 Query data from data source

3.2 Retrieve data from data source as result sets

3.3 Manage result sets

3.4 Manage exceptions when retrieving data

4. Modify data in data source

4.1 Insert, update or delete data

4.2 Manage data integrity

4.3 Manage exceptions when modifying data

5. Manage disconnected data

5.1 Research disconnected data management strategy

5.2 Ensure that application can deal with disconnected data

6. Document data-access layer

6.1 Document code

6.2 Document database connectivity

Evidence of the ability to:

select and code the data-access layer of multi-layer applications

retrieve and update data from various data sources.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

describe the features of object-oriented design and multi-layer applications

outline relational database management systems

describe object-oriented programming at an intermediate level

outline the principles of a Structured Query Language (SQL).